package com.globalwave.system.entity;

import javax.persistence.Column;

public class OrganizationCriterion {
    public final static String USER_BELONG_TO_ORGANIZATION = 
        "  select org.organization_id organization_id, " +
        //"         org.sys_organization_id sys_organization_id, " +
        "         org.pro_organization_id pro_organization_id, " +
        "         org.name_ name_, " +
        "         org.desc_ desc_, " +
        "         uo.user_id user_id" +
        "    from system_organization org " +
        "         left join system_user_organization uo " +
        "                on org.organization_id = uo.organization_id " +
        "               and uo.user_id='%s' " +
        "order by org.organization_id" ;
    
    
    @Column(name="organization_id")
    private Long[] organizationIds ;


    public Long[] getOrganizationIds() {
        return organizationIds;
    }
    public void setOrganizationIds(Long[] organizationIds) {
        this.organizationIds = organizationIds;
    } 
}
